class AddDateToEcase < ActiveRecord::Migration
  def self.up
    execute "ALTER TABLE `ecases` ADD `date` VARCHAR(20) DEFAULT '1970-01-01 00:00:00'  NOT NULL"
    execute "ALTER TABLE `events` CHANGE `date` `date` VARCHAR(20) DEFAULT '1970-01-01 00:00:00'  NOT NULL"
  end

  def self.down
    execute 'ALTER TABLE `events` CHANGE `date` `date` TINYTEXT NOT NULL'
    execute 'ALTER TABLE `ecases` DROP COLUMN `date` '
  end
end
